object DataModule1: TDataModule1
  OldCreateOrder = False
  OnCreate = DataModuleCreate
  Height = 717
  Width = 1719
  object producto: TADOTable
    Connection = ADOConnection1
    CursorType = ctStatic
    TableName = 'producto'
    Left = 224
    Top = 48
    object productoid_prod: TAutoIncField
      FieldName = 'id_prod'
      ReadOnly = True
    end
    object productonombre_prod: TStringField
      FieldName = 'nombre_prod'
      Size = 255
    end
    object productodescripcion_prod: TStringField
      FieldName = 'descripcion_prod'
      Size = 255
    end
    object productotipo_prod: TStringField
      FieldName = 'tipo_prod'
      Size = 255
    end
    object productosexo_prod: TStringField
      FieldName = 'sexo_prod'
      Size = 255
    end
    object productofoto_prod: TBlobField
      FieldName = 'foto_prod'
    end
    object productoprecio_unitario: TFloatField
      FieldName = 'precio_unitario'
    end
    object productoprecio_xmayor: TFloatField
      FieldName = 'precio_xmayor'
    end
  end
  object talle_remera: TADOTable
    Connection = ADOConnection1
    CursorType = ctStatic
    TableName = 'talle_remera'
    Left = 296
    Top = 48
  end
  object talle_pantalon: TADOTable
    Connection = ADOConnection1
    CursorType = ctStatic
    TableName = 'talle_pantalon'
    Left = 376
    Top = 48
  end
  object talle_cinturon: TADOTable
    Connection = ADOConnection1
    CursorType = ctStatic
    TableName = 'talle_cinturon'
    Left = 464
    Top = 48
  end
  object dsproducto: TDataSource
    DataSet = producto
    Left = 224
    Top = 128
  end
  object dstalle_remera: TDataSource
    DataSet = talle_remera
    Left = 296
    Top = 128
  end
  object dstalle_pantalon: TDataSource
    DataSet = talle_pantalon
    Left = 384
    Top = 128
  end
  object dstalle_cinturon: TDataSource
    DataSet = talle_cinturon
    Left = 472
    Top = 128
  end
  object QstockTotal: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select p.id_prod, p.nombre_prod, p.sexo_prod, tp.26, tp.28,'
      'tp.30, tp.32, tp.34, tp.36, tp.38, tp.40, tp.42, tp.44, tp.46,'
      'tp.48, tp.50, tp.52, tp.54, tp.56, tp.58, tp.60, tr.xs, tr.s'
      
        'tr.m, tr.l, tr.xl, tr.xxl, tr.xxxl, tc.90, tc.95, tc.100, tc.105' +
        ', tc.110'
      'from producto p '
      'left join talle_pantalon tp on p.id_prod = tp.id_prod'
      'left join talle_remera tr on p.id_prod = tr.id_prod'
      'left join talle_cinturon tc on p.id_prod = tc.id_prod')
    Left = 224
    Top = 208
  end
  object dsQstockTotal: TDataSource
    DataSet = QstockTotal
    Left = 224
    Top = 264
  end
  object cliente: TADOTable
    Connection = ADOConnection1
    CursorType = ctStatic
    TableName = 'cliente'
    Left = 544
    Top = 48
  end
  object dscliente: TDataSource
    DataSet = cliente
    Left = 544
    Top = 128
  end
  object Qcliente: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from cliente')
    Left = 216
    Top = 336
  end
  object dsqcliente: TDataSource
    DataSet = Qcliente
    Left = 216
    Top = 392
  end
  object QstockRemera: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select p.nombre_prod,p.id_prod, p.descripcion_prod, p.tipo_prod,' +
        ' p.sexo_prod, '
      
        'p.precio_unitario, tr.xs, tr.s, tr.m, tr.l, tr.xl, tr.xxl, tr.xx' +
        'xl, (tr.xs + tr.s + tr.m + tr.l + tr.xl + tr.xxl + tr.xxxl) as t' +
        'otal from producto p '
      'left join talle_remera tr on p.id_prod = tr.id_prod'
      'where p.tipo_prod="remera"')
    Left = 296
    Top = 208
  end
  object dsQstockRemera: TDataSource
    DataSet = QstockRemera
    Left = 296
    Top = 264
  end
  object QstockPantalon: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select p.nombre_prod,p.id_prod,  p.descripcion_prod, p.tipo_prod' +
        ', p.sexo_prod, '
      
        'p.precio_unitario, tp.26, tp.28, tp.30, tp.32, tp.34, tp.36, tp.' +
        '38, tp.40, '
      'tp.42, tp.44, tp.46, tp.48, tp.50, tp.52, tp.54, '
      
        ' (tp.26 + tp.28 + tp.30 + tp.32 + tp.34 + tp.36 + tp.38 + tp.40 ' +
        '+ tp.42 '
      
        '+ tp.44 + tp.46 + tp.48 + tp.50 + tp.52 + tp.54) as total from p' +
        'roducto p'
      ' left join talle_pantalon tp on p.id_prod = tp.id_prod'
      'where p.tipo_prod="pantalon"')
    Left = 384
    Top = 208
  end
  object dsQstockPantalon: TDataSource
    DataSet = QstockPantalon
    Left = 384
    Top = 264
  end
  object QstockCinturon: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select p.nombre_prod, p.id_prod, p.descripcion_prod, p.tipo_prod' +
        ', p.sexo_prod, '
      
        'p.precio_unitario, tc.90, tc.95, tc.100, tc.105, tc.110, (tc.90 ' +
        '+ tc.95 + tc.100 + tc.105 + tc.110) as total from producto p '
      'left join talle_cinturon tc on p.id_prod = tc.id_prod'
      'where p.tipo_prod="cinturon"')
    Left = 472
    Top = 208
  end
  object dsQstockCinturon: TDataSource
    DataSet = QstockCinturon
    Left = 472
    Top = 264
  end
  object venta: TADOTable
    Connection = ADOConnection1
    TableName = 'venta'
    Left = 616
    Top = 48
  end
  object detalle_venta: TADOTable
    Connection = ADOConnection1
    TableName = 'detalle_venta'
    Left = 688
    Top = 48
  end
  object dsVenta: TDataSource
    DataSet = venta
    Left = 616
    Top = 120
  end
  object dsDetalle_Venta: TDataSource
    DataSet = detalle_venta
    Left = 688
    Top = 120
  end
  object QRemito: TADOQuery
    Connection = ADOConnection1
    Parameters = <>
    Left = 568
    Top = 208
  end
  object dsRemito: TDataSource
    DataSet = QRemito
    Left = 568
    Top = 264
  end
  object Qventa: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from venta v'
      'inner join detalle_venta d on v.id_venta = d.id_venta'
      'inner join cliente c on v.id_cliente = c.id_cliente'
      'group by v.id_venta')
    Left = 296
    Top = 336
  end
  object dsqventa: TDataSource
    DataSet = Qventa
    Left = 296
    Top = 392
  end
  object QreportePantalonH: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from producto p '
      'inner join talle_pantalon tp on p.id_prod = tp.id_prod'
      'where p.tipo_prod="pantalon" and p.sexo_prod="hombre"')
    Left = 216
    Top = 456
  end
  object QreporteRemeraH: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from producto p '
      'left join talle_remera tr on p.id_prod = tr.id_prod'
      'where p.tipo_prod="remera" and p.sexo_prod="hombre"')
    Left = 336
    Top = 456
  end
  object QreporteCinturonH: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from producto p '
      'left join talle_cinturon tc on p.id_prod = tc.id_prod'
      'where p.tipo_prod="cinturon" and p.sexo_prod="hombre"')
    Left = 464
    Top = 456
  end
  object dsreportePantalonH: TDataSource
    DataSet = QreportePantalonH
    Left = 216
    Top = 520
  end
  object dsreporteRemeraH: TDataSource
    DataSet = QreporteRemeraH
    Left = 336
    Top = 520
  end
  object dsreporteCinturonH: TDataSource
    DataSet = QreporteCinturonH
    Left = 464
    Top = 520
  end
  object QreportePantalonM: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from producto p '
      'left join talle_pantalon tp on p.id_prod = tp.id_prod'
      'where p.tipo_prod="pantalon" and p.sexo_prod="dama"')
    Left = 216
    Top = 584
  end
  object dsreportePantalonM: TDataSource
    DataSet = QreportePantalonM
    Left = 216
    Top = 644
  end
  object QreporteRemeraM: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from producto p '
      'left join talle_remera tr on p.id_prod = tr.id_prod'
      'where p.tipo_prod="remera" and p.sexo_prod="dama"')
    Left = 336
    Top = 584
  end
  object dsreporteRemeraM: TDataSource
    DataSet = QreporteRemeraM
    Left = 336
    Top = 640
  end
  object QreporteCinturonM: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from producto p '
      'left join talle_cinturon tc on p.id_prod = tc.id_prod'
      'where p.tipo_prod="cinturon" and p.sexo_prod="dama"')
    Left = 464
    Top = 584
  end
  object dsreporteCinturonM: TDataSource
    DataSet = QreporteCinturonM
    Left = 464
    Top = 640
  end
  object ADOConnection1: TADOConnection
    Connected = True
    ConnectionString = 
      'Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Data' +
      ' Source=bd local;Initial Catalog=drmorant_cyc'
    LoginPrompt = False
    Left = 88
    Top = 56
  end
  object talle_media: TADOTable
    Connection = ADOConnection1
    TableName = 'talle_media'
    Left = 784
    Top = 48
  end
  object dstalle_media: TDataSource
    DataSet = talle_media
    Left = 784
    Top = 120
  end
  object talle_bolsa: TADOTable
    Connection = ADOConnection1
    TableName = 'talle_bolsa'
    Left = 872
    Top = 48
  end
  object dstalle_bolsa: TDataSource
    DataSet = talle_bolsa
    Left = 872
    Top = 120
  end
  object QstockMedia: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select p.nombre_prod, p.descripcion_prod, p.tipo_prod, p.sexo_pr' +
        'od, '
      
        'p.precio_unitario, tm.negro, tm.gris, tm.azul, tm.aero, tm.blanc' +
        'a, (tm.negro + tm.gris + tm.azul + tm.aero + tm.blanca) as total' +
        ' from producto p '
      'left join talle_media tm on p.id_prod = tm.id_prod'
      'where p.tipo_prod="media"')
    Left = 664
    Top = 208
  end
  object QstockBolsa: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select p.nombre_prod, p.descripcion_prod, p.tipo_prod, p.sexo_pr' +
        'od, '
      
        'p.precio_unitario, tb.1, tb.2, tb.3, tb.4, (tb.1 + tb.2 + tb.3 +' +
        ' tb.4) as total from producto p '
      'left join talle_bolsa tb on p.id_prod = tb.id_prod'
      'where p.tipo_prod="bolsa"')
    Left = 752
    Top = 208
  end
  object dsQstockMedia: TDataSource
    DataSet = QstockMedia
    Left = 664
    Top = 264
  end
  object dsQstockBolsa: TDataSource
    DataSet = QstockBolsa
    Left = 752
    Top = 264
  end
  object QCCCliente: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from venta v'
      'inner join detalle_venta d on v.id_venta = d.id_venta'
      'inner join cliente c on v.id_cliente = c.id_cliente'
      'where v.cc = 1'
      'group by v.id_venta')
    Left = 392
    Top = 336
  end
  object dsqcccliente: TDataSource
    DataSet = QCCCliente
    Left = 392
    Top = 392
  end
  object pago: TADOTable
    Connection = ADOConnection1
    TableName = 'pago'
    Left = 960
    Top = 48
  end
  object dspago: TDataSource
    DataSet = pago
    Left = 960
    Top = 120
  end
  object Qpagos: TADOQuery
    Connection = ADOConnection1
    Parameters = <>
    Left = 472
    Top = 336
  end
  object dsQpagos: TDataSource
    DataSet = Qpagos
    Left = 472
    Top = 392
  end
  object taller: TADOTable
    Connection = ADOConnection1
    TableName = 'taller'
    Left = 1040
    Top = 48
  end
  object dstaller: TDataSource
    DataSet = taller
    Left = 1040
    Top = 120
  end
  object Qtaller: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from taller')
    Left = 560
    Top = 344
  end
  object dsqtaller: TDataSource
    DataSet = Qtaller
    Left = 560
    Top = 400
  end
  object avio: TADOTable
    Connection = ADOConnection1
    CursorType = ctStatic
    TableName = 'avio'
    Left = 1112
    Top = 48
  end
  object dsavio: TDataSource
    DataSet = avio
    Left = 1112
    Top = 120
  end
  object QstockAvio: TADOQuery
    Connection = ADOConnection1
    Parameters = <>
    SQL.Strings = (
      'select * from avio')
    Left = 840
    Top = 208
  end
  object dsQstockAvio: TDataSource
    DataSet = QstockAvio
    Left = 832
    Top = 264
  end
  object foto_avio: TADOTable
    Connection = ADOConnection1
    CursorType = ctStatic
    TableName = 'foto_avio'
    Left = 1176
    Top = 48
    object foto_avioid_foto_avio: TAutoIncField
      FieldName = 'id_foto_avio'
      ReadOnly = True
    end
    object foto_avioid_avio: TIntegerField
      FieldName = 'id_avio'
    end
    object foto_aviofoto_avio: TBlobField
      FieldName = 'foto_avio'
    end
  end
  object dsfoto_avio: TDataSource
    DataSet = foto_avio
    Left = 1176
    Top = 120
  end
  object QreporteBolsa: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    DataSource = dsQstockBolsa
    Parameters = <>
    SQL.Strings = (
      'select * from producto p '
      'left join talle_bolsa tb on p.id_prod = tb.id_prod'
      'where p.tipo_prod="bolsa"')
    Left = 752
    Top = 336
  end
  object QreporteMedia: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    DataSource = dsreporteMedia
    Parameters = <>
    SQL.Strings = (
      'select * from producto p '
      'left join talle_media tm on p.id_prod = tm.id_prod'
      'where p.tipo_prod="media" ')
    Left = 664
    Top = 336
  end
  object dsreporteMedia: TDataSource
    Left = 664
    Top = 400
  end
  object dsreporteBolsa: TDataSource
    DataSet = QreporteBolsa
    Left = 752
    Top = 400
  end
  object QreporteAvio: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from avio ')
    Left = 1112
    Top = 208
  end
  object QreporteTaller: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from taller')
    Left = 560
    Top = 456
  end
  object dsreporteAvio: TDataSource
    DataSet = QreporteAvio
    Left = 1112
    Top = 264
  end
  object dsreporteTaller: TDataSource
    DataSet = QreporteTaller
    Left = 560
    Top = 520
  end
  object corte: TADOTable
    Connection = ADOConnection1
    TableName = 'corte'
    Left = 1248
    Top = 64
  end
  object dscorte: TDataSource
    DataSet = corte
    Left = 1256
    Top = 128
  end
  object detalle_corte_avio: TADOTable
    Connection = ADOConnection1
    TableName = 'detalle_corte_avio'
    Left = 1320
    Top = 72
  end
  object dsdetalle_corte: TDataSource
    DataSet = detalle_corte_avio
    Left = 1320
    Top = 144
  end
  object detalle_corte_producto: TADOTable
    Connection = ADOConnection1
    TableName = 'detalle_corte_producto'
    Left = 1424
    Top = 48
  end
  object dsdetalle_corte_producto: TDataSource
    DataSet = detalle_corte_producto
    Left = 1432
    Top = 136
  end
  object Qcorte: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from corte c'
      'inner join taller t on c.id_taller = t.id_taller'
      'inner join producto p on p.id_prod = c.id_producto '
      'group by c.id_corte')
    Left = 840
    Top = 352
  end
  object dsqcorte: TDataSource
    DataSet = Qcorte
    Left = 856
    Top = 416
  end
  object QMercaderia: TADOQuery
    Connection = ADOConnection1
    Parameters = <>
    Left = 960
    Top = 352
  end
  object dsqmercaderia: TDataSource
    DataSet = QMercaderia
    Left = 976
    Top = 432
  end
end
